#pragma once
#include <iostream>
#include <cstddef>
#include <odb/core.hxx>
#include <odb/nullable.hxx>

#include "chat_session_member.hxx"

enum class ChatSessionType
{
    SINGLE = 1,
    GROUP = 2
};

#pragma db object table("chat_session")
class ChatSession
{
public:
    ChatSession() {}

    ~ChatSession() {}

    ChatSession(const std::string &ssid,
                const std::string &ssname,
                const ChatSessionType &sstype)
        : _chat_session_id(ssid),
          _chat_session_name(ssname),
          _chat_session_type(sstype) {}

        
    std::string chat_session_id() { return _chat_session_id; }
    void set_chat_session_id(const std::string& ssid) { _chat_session_id = ssid; }

    std::string chat_session_name() { return _chat_session_name; }
    void set_chat_session_name(const std::string& ssname) { _chat_session_name = ssname; }

    
    ChatSessionType chat_session_type() { return _chat_session_type; }
    void set_chat_session_type(const ChatSessionType& chat_session_type) { _chat_session_type = chat_session_type; } 


private:
    friend class odb::access;
#pragma db id auto
    unsigned long _id;
#pragma db type("varchar(64)") index unique
    std::string _chat_session_id;
#pragma db type("varchar(64)")
    std::string _chat_session_name;
#pragma db type("tinyint")
    ChatSessionType _chat_session_type; // 1-单聊； 2-群聊
};

// css::chat_session_type==1 && csm1.user_id=uid && csm2.user_id != csm1.user_id
//这里要join2次表，因为第一次帅选后，不能将自己排除出去
#pragma db view object(ChatSession = css)\
                object(ChatSessionMember = csm1 : css::_chat_session_id == csm1::_session_id)\
                object(ChatSessionMember = csm2 : css::_chat_session_id == csm2::_session_id)\
                query((?))

struct SingleChatSession    
{
    #pragma db column(css::_chat_session_id)
    std::string chat_session_id;
    #pragma db column(csm2::_user_id)
    std::string friend_id;
};

#pragma db view object(ChatSession = css)\
                object(ChatSessionMember = csm1 : css::_chat_session_id == csm1::_session_id)\
                query((?))
struct GroupChatSession
{
    #pragma db column(css::_chat_session_id)
    std::string chat_session_id;
    #pragma db column(css::_chat_session_name)
    std::string chat_session_name;
};

